002
SELECT contentDB.contentID,contentDB.bookID,contentDB.sceneID,contentDB.mediaType,contentDB.mediaInfo,contentDB.webAllowed,contentDB.webAllowed2,contentDB.clientAllowed,contentDB.dvdAllowed,contentDB.tbProd,contentDB.type,contentDB.sceneType,contentDB.dateAdded,contentDB.name,contentDB.prodNotes,contentDB.prodDate,contentDB.backup,contentDB.story,contentDB.nickname,contentDB.folderName,contentDB.fileID,contentDB.searchKeys,contentDB.extURL,contentDB.cgID,contentDB.schedSeq,contentDB.picsComplete,contentDB.picsUploaded,contentDB.vidsUploaded,contentDB.vidsComplete,contentDB.contentNotes,contentDB.dueDate,contentDB.x2257,contentDB.captured,contentDB.dvdID,contentDB.pics,contentDB.vids,contentDB.recieved,contentDB.recDate,contentDB.shipped,contentDB.shipDate,contentDB.note1,contentDB.desc25,contentDB.desc50,contentDB.widescreen,contentDB.PicSent,contentDB.PicReceived,contentDB.VidSent,contentDB.VidReceived,contentDB.picGal,contentDB.picGalExist,contentDB.vidGal,contentDB.vidGalExist,contentDB.staff_pick,contentDB.screenType,contentDB.useNewPreview,contentDB.nSeq,contentDB.title_sub,contentDB.x264,contentDB.spankmo,contentDB.dvdCover,contentDB.nCap,contentDB.useRestrict,contentDB.s5m,contentDB.cdn,contentDB.vidsrc,contentDB.nupload,siteScenes.ssID,siteScenes.siteID,siteScenes.contentID,siteScenes.sceneNum,siteScenes.status,siteScenes.schedStart,siteScenes.schedEnd,siteScenes.story,siteScenes.short,siteScenes.nickname,siteScenes.currentlyFeat,siteScenes.oemFeat,siteScenes.promotional,siteScenes.onSale,siteScenes.dateAdded,siteScenes.pageClass,siteScenes.wmView,siteScenes.lockClass,siteScenes.totalClicks,siteScenes.resClicks,siteScenes.avgClicks,siteScenes.votes FROM contentDB,siteScenes WHERE contentDB.contentID=siteScenes.contentID AND contentDB.mediaType=1 AND siteScenes.status='active' AND contentDB.cgID IN (217,170) AND contentDB.cgID>0 ORDER BY siteScenes.schedStart desc LIMIT -1,20
simpleQuery("contentDB,siteScenes","contentDB.contentID,contentDB.bookID,contentDB.sceneID,contentDB.mediaType,contentDB.mediaInfo,contentDB.webAllowed,contentDB.webAllowed2,contentDB.clientAllowed,contentDB.dvdAllowed,contentDB.tbProd,contentDB.type,contentDB.sceneType,contentDB.dateAdded,contentDB.name,contentDB.prodNotes,contentDB.prodDate,contentDB.backup,contentDB.story,contentDB.nickname,contentDB.folderName,contentDB.fileID,contentDB.searchKeys,contentDB.extURL,contentDB.cgID,contentDB.schedSeq,contentDB.picsComplete,contentDB.picsUploaded,contentDB.vidsUploaded,contentDB.vidsComplete,contentDB.contentNotes,contentDB.dueDate,contentDB.x2257,contentDB.captured,contentDB.dvdID,contentDB.pics,contentDB.vids,contentDB.recieved,contentDB.recDate,contentDB.shipped,contentDB.shipDate,contentDB.note1,contentDB.desc25,contentDB.desc50,contentDB.widescreen,contentDB.PicSent,contentDB.PicReceived,contentDB.VidSent,contentDB.VidReceived,contentDB.picGal,contentDB.picGalExist,contentDB.vidGal,contentDB.vidGalExist,contentDB.staff_pick,contentDB.screenType,contentDB.useNewPreview,contentDB.nSeq,contentDB.title_sub,contentDB.x264,contentDB.spankmo,contentDB.dvdCover,contentDB.nCap,contentDB.useRestrict,contentDB.s5m,contentDB.cdn,contentDB.vidsrc,contentDB.nupload,siteScenes.ssID,siteScenes.siteID,siteScenes.contentID,siteScenes.sceneNum,siteScenes.status,siteScenes.schedStart,siteScenes.schedEnd,siteScenes.story,siteScenes.short,siteScenes.nickname,siteScenes.currentlyFeat,siteScenes.oemFeat,siteScenes.promotional,siteScenes.onSale,siteScenes.dateAdded,siteScenes.pageClass,siteScenes.wmView,siteScenes.lockClass,siteScenes.totalClicks,siteScenes.resClicks,siteScenes.avgClicks,siteScenes.votes","WHERE contentDB.contentID=siteScenes.contentID AND contentDB.mediaType=1 AND siteScenes.status='active' AND contentDB.cgID IN (217,170) AND contentDB.cgID>0","ORDER BY siteScenes.schedStart desc LIMIT -1,20")
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1,20' at line 1